package w83b.w83bDAO;



import java.util.ArrayList;
import java.util.List;

import javax.naming.NamingException;

import w83b.util.jdbc.W83bDataBase;
import w83b.w83bBeans.W83bMigracionBean;
import w83b.w83bDAO.w83bConstantesBD.W83bMigracionBD;
import w83b.w83bUtilidadesComunes.W83bClsConstantes;
import w83b.w83bUtilidadesComunes.W83bClsTrazas;


// TODO: Auto-generated Javadoc
/**
 * The Class W83bMigracionDAO.
 * @author a
 */
public class W83bMigracionDAO implements W83bIMigracionDAO{
	
	/**
	 * generarMigracion.
	 * 
	 * @throws Exception the exception
	 */
	public void generarMigracion() throws Exception{
		
		W83bClsTrazas.trazaDebug(null, "EMPIEZO A MIGRAAAAR!!!!");
		this.borrarTablas();
		this.insertarTablas();
		
			
	}
	
	/**
	 * Borrar tablas.
	 * 
	 * @throws Exception the exception
	 */
	public void borrarTablas() throws Exception{
		this.borrar64();
		this.borrar41();
		this.borrar38();
		this.borrar34();
		this.borrar20();
		this.borrar76();
		this.borrar74();
		this.borrar73();
		this.borrar72();
		this.borrar71();
		this.borrar70();
		this.borrar69();
		this.borrar68();
		this.borrar67();
		this.borrar66();
		this.borrar61();
		this.borrar60();
		this.borrar59();
		this.borrar58();
		this.borrar44();
		this.borrar35();
		this.borrar33();
		this.borrar27();
		this.borrar24();
		this.borrar18();
		this.borrar16();
		this.borrar56();
		this.borrar55();
		this.borrar54();
		this.borrar53();
		this.borrar37();
		this.borrar31();
		this.borrar25();
		this.borrar15();
		this.borrar13();
		this.borrar12();
		this.borrar75();
		this.borrar65();
		this.borrar63();
		this.borrar62();
		this.borrar52();
		this.borrar42();
		this.borrar40();
		this.borrar36();
		this.borrar32();
		this.borrar30();
		this.borrar29();
		this.borrar26();
		this.borrar23();
		this.borrar21();
		this.borrar19();
		this.borrar17();
		this.borrar14();
		
	}
	
	
	/**
	 * Insertar tablas.
	 * 
	 * @throws Exception the exception
	 */
	public void insertarTablas() throws Exception{
		this.insertar14();
		this.insertar17();
		this.insertar19();
		this.insertar21();
		this.insertar23();
		this.insertar26();
		this.insertar29();
		this.insertar30();
		this.insertar32();
		this.insertar36();
		this.insertar40();
		this.insertar42();
		this.insertar52();
		this.insertar62();
		this.insertar63();
		//this.insertar65();
		this.insertar75();
		this.insertar12();
		this.insertar13();
		this.insertar15();
		this.insertar25();
		this.insertar31();
		this.insertar37();
		this.insertar53();
		/*this.insertar54();
		this.insertar55();
		this.insertar56();*/
		this.insertar16();
		this.insertar18();
		this.insertar24();
		//this.insertar27();
		this.insertar33();
		/*this.insertar35();
		this.insertar44();
		this.insertar58();
		this.insertar59();
		this.insertar60();
		this.insertar61();
		this.insertar66();
		this.insertar67();
		this.insertar68();
		this.insertar69();
		this.insertar70();
		this.insertar71();
		this.insertar72();
		this.insertar73();
		this.insertar74();
		this.insertar76();
		this.insertar20();
		this.insertar34();
		this.insertar38();
		this.insertar41();
		this.insertar64();*/
	}
	
	/**
	 * Borrar64.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar64() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 64 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla64);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar41.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar41() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 41----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla41);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar38.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar38() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 38 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla38);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar34.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar34() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 34 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla34);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar20.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar20() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 20 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla20);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar76.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar76() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 76 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla76);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar74.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar74() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 74 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla74);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar73.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar73() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 73 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla73);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar72.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar72() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 72 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla72);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar71.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar71() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 71 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla71);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar70.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar70() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 70 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla70);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar69.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar69() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 69 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla69);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar68.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar68() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 68 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla68);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar67.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar67() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 67 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla67);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar66.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar66() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 66 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla66);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar61.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar61() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 61 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla61);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar60.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar60() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 60 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla60);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar59.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar59() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 59 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla59);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar58.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar58() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 58 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla58);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar44.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar44() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 44 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla44);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar35.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar35() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 35 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla35);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar33.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar33() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 33 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla33);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar27.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar27() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 27 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla27);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar24.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar24() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 24 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla24);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar18.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar18() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 18 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla18);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar16.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar16() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 16 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla16);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar56.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar56() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 56 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla56);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar55.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar55() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 55 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla55);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar54.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar54() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 54 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla54);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar53.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar53() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 53 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla53);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar37.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar37() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 37 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla37);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar31.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar31() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 31 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla31);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar25.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar25() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 25 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla25);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar15.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar15() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 15 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla15);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar13.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar13() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 13 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla13);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar12.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar12() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 12 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla12);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar75.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar75() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 75 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla75);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar65.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar65() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 65 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla65);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar63.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar63() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 63 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla63);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar62.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar62() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 62 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla62);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
		
	/**
	 * Borrar52.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar52() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 52 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla52);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
		
	
	/**
	 * Borrar42.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar42() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 42 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla42);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar40.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar40() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 40 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla40);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar36.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar36() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 36 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla36);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar32.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar32() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 32 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla32);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar30.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar30() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 30 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla30);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar29.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar29() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 29 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla29);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar26.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar26() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 26 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla26);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar23.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar23() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 23 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla23);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar21.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar21() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 21 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla21);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar19.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar19() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 19 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla19);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar17.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar17() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 17 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla17);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Borrar14.
	 * 
	 * @throws Exception the exception
	 */
	private void borrar14() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- BORRA LA 14 ----------");
		strSql.append("DELETE FROM ").append(W83bMigracionBD.tabla14);
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
	} 
	
	/**
	 * Insertar14.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar14() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 14 ----------");
		strSql.append("SELECT ").append(W83bMigracionBD.codAgrup01);
		strSql.append(",").append(W83bMigracionBD.desCas01);
		strSql.append(" FROM ").append(W83bMigracionBD.tablad161);
				
		List lista = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
		W83bMigracionBean registro = new W83bMigracionBean();
		for(int i=0;i<lista.size();i++){
			registro = (W83bMigracionBean)lista.get(i);
			
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append(" INSERT INTO ").append(W83bMigracionBD.tabla14).append(" (");
			strSql.append(W83bMigracionBD.codAgru014).append(",").append(W83bMigracionBD.desCas014);
			strSql.append(",").append(W83bMigracionBD.desEus014).append(") ");
			strSql.append(" VALUES (").append(registro.getCodAgrupacion01()).append(",");
			strSql.append(registro.getDesCastellano01()).append(",");
			strSql.append("EUS_").append(registro.getDesCastellano01()).append(")");
		
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	
	/**
	 * Insertar17.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar17() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 17 ----------");
		strSql.append("SELECT ").append(W83bMigracionBD.codBaja04);
		strSql.append(",").append(W83bMigracionBD.desCas04);
		strSql.append(" FROM ").append(W83bMigracionBD.tablad164);
				
		List lista = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
		W83bMigracionBean registro = new W83bMigracionBean();
		for(int i=0;i<lista.size();i++){
			registro = (W83bMigracionBean)lista.get(i);
			
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla17).append(" (");
			strSql.append(W83bMigracionBD.cBaja017).append(",").append(W83bMigracionBD.desCas017);
			strSql.append(",").append(W83bMigracionBD.desEus017).append(") ");
			strSql.append(" VALUES (").append(registro.getCodBaja04()).append(",");
			strSql.append(registro.getDesCastellano04()).append(",");
			strSql.append("EUS_").append(registro.getDesCastellano04()).append(")");
		
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	
	/**
	 * Insertar19.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar19() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 19 ----------");
		strSql.append("SELECT ").append(W83bMigracionBD.codSindi03);
		strSql.append(",").append(W83bMigracionBD.desCas03);
		strSql.append(",").append(W83bMigracionBD.siglas03);
		strSql.append(",").append(W83bMigracionBD.codVerif03);
		strSql.append(",").append(W83bMigracionBD.codMadrid03);
		strSql.append(",").append(W83bMigracionBD.relStes03);
		strSql.append(" FROM ").append(W83bMigracionBD.tablad163);
				
		List lista = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
		W83bMigracionBean registro = new W83bMigracionBean();
		for(int i=0;i<lista.size();i++){
			registro = (W83bMigracionBean)lista.get(i);
			
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla19).append(" (");
			strSql.append(W83bMigracionBD.codSindi019).append(",").append(W83bMigracionBD.desCas019);
			strSql.append(",").append(W83bMigracionBD.siglas019).append(", ");
			strSql.append(",").append(W83bMigracionBD.cVerif019).append(", ");
			strSql.append(",").append(W83bMigracionBD.cMadrid019).append(", ");
			strSql.append(",").append(W83bMigracionBD.relStes019).append(", ");
			strSql.append(",").append(W83bMigracionBD.desEus019).append(") ");
			strSql.append(" VALUES (").append(registro.getCodSindi03()).append(",");
			strSql.append(registro.getDesCas03()).append(",");
			strSql.append(registro.getSiglas03()).append(",");
			strSql.append(registro.getCodVerif03()).append(",");
			strSql.append(registro.getCodMadrid03()).append(",");
			strSql.append(registro.getRelStes03()).append(",");
			strSql.append("EUS_").append(registro.getDesCas03()).append(")");		
		
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	
	/**
	 * Insertar21.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar21() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 21 ----------");
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla21);
		strSql.append(" ( ").append(W83bMigracionBD.tpConv021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabDesde021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabHasta021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.numDeleg021).append(")");
		strSql.append(" VALUES ('A', 6, 30, 1)");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla21);
		strSql.append(" ( ").append(W83bMigracionBD.tpConv021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabDesde021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabHasta021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.numDeleg021).append(")");
		strSql.append(" VALUES ('A', 31, 49, 3)");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla21);
		strSql.append(" ( ").append(W83bMigracionBD.tpConv021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabDesde021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabHasta021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.numDeleg021).append(")");
		strSql.append(" VALUES ('A', 50, 100, 5)"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla21);
		strSql.append(" ( ").append(W83bMigracionBD.tpConv021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabDesde021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabHasta021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.numDeleg021).append(")");
		strSql.append(" VALUES ('A', 101, 250, 7)"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla21);
		strSql.append(" ( ").append(W83bMigracionBD.tpConv021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabDesde021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabHasta021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.numDeleg021).append(")");
		strSql.append(" VALUES ('A', 251, 500, 11)");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla21);
		strSql.append(" ( ").append(W83bMigracionBD.tpConv021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabDesde021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabHasta021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.numDeleg021).append(")");
		strSql.append(" VALUES ('A', 501, 750, 15)"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla21);
		strSql.append(" ( ").append(W83bMigracionBD.tpConv021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabDesde021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabHasta021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.numDeleg021).append(")"); 
		strSql.append(" VALUES ('A', 751, 1000, 19)"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla21);
		strSql.append(" ( ").append(W83bMigracionBD.tpConv021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabDesde021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabHasta021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.numDeleg021).append(")");
		strSql.append(" VALUES ('O', 6, 30, 1)");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla21);
		strSql.append(" ( ").append(W83bMigracionBD.tpConv021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabDesde021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabHasta021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.numDeleg021).append(")");
		strSql.append(" VALUES ('O', 31, 49, 3)"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla21);
		strSql.append(" ( ").append(W83bMigracionBD.tpConv021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabDesde021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabHasta021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.numDeleg021).append(")");
		strSql.append(" VALUES ('O', 50, 100, 5)");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla21);
		strSql.append(" ( ").append(W83bMigracionBD.tpConv021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabDesde021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabHasta021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.numDeleg021).append(")");
		strSql.append(" VALUES ('O', 101, 250, 9)");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla21);
		strSql.append(" ( ").append(W83bMigracionBD.tpConv021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabDesde021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabHasta021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.numDeleg021).append(")"); 
		strSql.append(" VALUES ('O', 251, 500, 13)"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla21);
		strSql.append(" ( ").append(W83bMigracionBD.tpConv021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabDesde021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabHasta021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.numDeleg021).append(")");
		strSql.append(" VALUES ('O', 501, 750, 17)");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla21);
		strSql.append(" ( ").append(W83bMigracionBD.tpConv021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabDesde021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.trabHasta021).append(",");
		strSql.append(" , ").append(W83bMigracionBD.numDeleg021).append(")");
		strSql.append(" VALUES ('O', 751, 1000, 21)");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}

		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	/**
	 * Insertar23.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar23() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 23 ----------");
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla23); 
		strSql.append(" ( ").append(W83bMigracionBD.codColeg023).append(",");
		strSql.append(" , ").append(W83bMigracionBD.desCas023).append(",");
		strSql.append(" , ").append(W83bMigracionBD.desEus023).append(")");
		strSql.append(" VALUES (0, 'TÉCNICOS Y ADMINISTRATIVOS', 'EUS-TÉCNICOS Y ADMINISTRATIVOS')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla23); 
		strSql.append(" ( ").append(W83bMigracionBD.codColeg023).append(",");
		strSql.append(" , ").append(W83bMigracionBD.desCas023).append(",");
		strSql.append(" , ").append(W83bMigracionBD.desEus023).append(")");
		strSql.append(" VALUES (1, 'ESPECIALISTAS Y NO CUALIFICADOS', 'EUS-ESPECIALISTAS Y NO CUALIFICADOS')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	
	
	/**
	 * Insertar26.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar26() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 26 ----------");
		strSql.append("SELECT ").append(W83bMigracionBD.codBaja05);
		strSql.append(",").append(W83bMigracionBD.desCas05);
		strSql.append(" FROM ").append(W83bMigracionBD.tablad165);
				
		List lista = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
		W83bMigracionBean registro = new W83bMigracionBean();
		for(int i=0;i<lista.size();i++){
			registro = (W83bMigracionBean)lista.get(i);
			
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla26).append(" (");
			strSql.append(W83bMigracionBD.cBaja026).append(",").append(W83bMigracionBD.desCas026);
			strSql.append(",").append(W83bMigracionBD.desEus026).append(") ");
			strSql.append(" VALUES (").append(registro.getCodBaja05()).append(",");
			strSql.append(registro.getDesCastellano05()).append(",");
			strSql.append("EUS_").append(registro.getDesCastellano05()).append(")");
		
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	/**
	 * Insertar29.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar29() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 29 ----------");
		strSql.append("SELECT ").append(W83bMigracionBD.codEmpr06);
		strSql.append(",").append(W83bMigracionBD.desCas06);
		strSql.append(" FROM ").append(W83bMigracionBD.tablad166);
		
		List lista = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
		W83bMigracionBean registro = new W83bMigracionBean();
		for(int i=0;i<lista.size();i++){
			registro = (W83bMigracionBean)lista.get(i);
			
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla29).append(" (");
			strSql.append(W83bMigracionBD.codEmpr029).append(",").append(W83bMigracionBD.desCas029);
			strSql.append(",").append(W83bMigracionBD.desEus029).append(") ");
			strSql.append(" VALUES (").append(registro.getCodEmpr06()).append(",");
			strSql.append(registro.getDesCastellano06()).append(",");
			strSql.append("EUS_").append(registro.getDesCastellano06()).append(")");
			
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	
	/**
	 * Insertar30.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar30() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 30 ----------");
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla30); 
		strSql.append(" ( ").append(W83bMigracionBD.codImpug030).append(",");
		strSql.append(" , ").append(W83bMigracionBD.desCas030).append(",");
		strSql.append(" , ").append(W83bMigracionBD.desEus030).append(") ");
		strSql.append(" VALUES (1, 'EMPRESA', 'EUS-EMPRESA')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla30);
		strSql.append(" ( ").append(W83bMigracionBD.codImpug030).append(",");
		strSql.append(" , ").append(W83bMigracionBD.desCas030).append(",");
		strSql.append(" , ").append(W83bMigracionBD.desEus030).append(") ");
		strSql.append(" VALUES  (2, 'SINDICATO', 'EUS-SINDICATO')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
			
		
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	
	/**
	 * Insertar32.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar32() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 32 ----------");
		strSql.append("SELECT ").append(W83bMigracionBD.cTVoz26);
		strSql.append(",").append(W83bMigracionBD.desCas26);
		strSql.append(" FROM ").append(W83bMigracionBD.tablad1626);
		
		List lista = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
		W83bMigracionBean registro = new W83bMigracionBean();
		for(int i=0;i<lista.size();i++){
			registro = (W83bMigracionBean)lista.get(i);
			
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla32).append(" (");
			strSql.append(W83bMigracionBD.codTipvoz032).append(",").append(W83bMigracionBD.desCas032);
			strSql.append(",").append(W83bMigracionBD.desEus032).append(") ");
			strSql.append(" VALUES (").append(registro.getCTVoz26()).append(",");
			strSql.append(registro.getDesCastellano26()).append(",");
			strSql.append("EUS_").append(registro.getDesCastellano26()).append(")");
			
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 

	/**
	 * Insertar36.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar36() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 36 ----------");
		strSql.append("SELECT ").append(W83bMigracionBD.codTerrit08);
		strSql.append(",").append(W83bMigracionBD.dni08);
		strSql.append(",").append(W83bMigracionBD.nombre08);
		strSql.append(" FROM ").append(W83bMigracionBD.tablad168);
	
		List lista = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
		W83bMigracionBean registro = new W83bMigracionBean();
		for(int i=0;i<lista.size();i++){
			registro = (W83bMigracionBean)lista.get(i);
			
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla36).append(" (");
			strSql.append(W83bMigracionBD.codTerrit036).append(",").append(W83bMigracionBD.dni036);
			strSql.append(",").append(W83bMigracionBD.nombre036).append(") ");
			strSql.append(" VALUES (").append(registro.getCodTerrit08()).append(",");
			strSql.append(registro.getDni08()).append(",");
			strSql.append(registro.getNombre08()).append(")");
			
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 

	/**
	 * Insertar40.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar40() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 40 ----------");
		strSql.append("SELECT ").append(W83bMigracionBD.codTerrit07);
		strSql.append(",").append(W83bMigracionBD.nomDel07);
		strSql.append(",").append(W83bMigracionBD.nomRes07);
		strSql.append(",").append(W83bMigracionBD.nomSec07);
		strSql.append(" FROM ").append(W83bMigracionBD.tablad167);
			
		
		List lista = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
		W83bMigracionBean registro = new W83bMigracionBean();
		for(int i=0;i<lista.size();i++){
			registro = (W83bMigracionBean)lista.get(i);
			
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla40).append(" (");
			strSql.append(W83bMigracionBD.codTerrit040).append(",").append(W83bMigracionBD.nomDel040);
			strSql.append(W83bMigracionBD.nomRes040).append(",").append(W83bMigracionBD.nomSec040).append(") ");
			strSql.append(" VALUES (").append(registro.getCodTerrit07()).append(",");
			strSql.append(registro.getNomDel07()).append(",");
			strSql.append(registro.getNomRes07()).append(",");
			strSql.append(registro.getNomSec07()).append(")");
						
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	
	/**
	 * Insertar42.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar42() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 42 ----------");
		strSql.append("SELECT ").append(W83bMigracionBD.anoCierre16);
		strSql.append(",").append(W83bMigracionBD.mesCierre16);
		strSql.append(",").append(W83bMigracionBD.cierreAlav16);
		strSql.append(",").append(W83bMigracionBD.cierreGuip16);
		strSql.append(",").append(W83bMigracionBD.cierreViz16);
		strSql.append(" FROM ").append(W83bMigracionBD.tablad1616);		
		
		List lista = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
		W83bMigracionBean registro = new W83bMigracionBean();
		for(int i=0;i<lista.size();i++){
			registro = (W83bMigracionBean)lista.get(i);
			
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla42).append(" (");
			strSql.append(W83bMigracionBD.anoCierre042).append(",").append(W83bMigracionBD.mesCierre042);
			strSql.append(W83bMigracionBD.cierreAlav042).append(",");
			strSql.append(W83bMigracionBD.cierreGuip042).append(",");
			strSql.append(W83bMigracionBD.cierreViz042).append(") ");
			strSql.append(" VALUES (").append(registro.getAnoCierre16()).append(",");
			strSql.append(registro.getMesCierre16()).append(",");
			strSql.append(registro.getCierreAlav16()).append(",");
			strSql.append(registro.getCierreGuip16()).append(",");
			strSql.append(registro.getCierreViz16()).append(")");
			
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	
	/**
	 * Insertar52.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar52() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 52 ----------");
		
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla52); 
		strSql.append(" ( ").append(W83bMigracionBD.cFase052).append(","); 
		strSql.append(W83bMigracionBD.desCas052).append(","); 
		strSql.append(W83bMigracionBD.desEus052).append(")");  
		strSql.append(" VALUES (1, 'TRAMITACIÓN DEL PREAVISO', 'EUS-TRAMITACIÓN DEL PREAVISO')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla52); 
		strSql.append(" ( ").append(W83bMigracionBD.cFase052).append(","); 
		strSql.append(W83bMigracionBD.desCas052).append(","); 
		strSql.append(W83bMigracionBD.desEus052).append(")");  
		strSql.append(" VALUES (2, 'RECEPCIÓN DEL ACTA', 'EUS-RECEPCIÓN DEL ACTA')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla52); 
		strSql.append(" ( ").append(W83bMigracionBD.cFase052).append(","); 
		strSql.append(W83bMigracionBD.desCas052).append(","); 
		strSql.append(W83bMigracionBD.desEus052).append(")"); 
		strSql.append(" VALUES (3, 'ACEPTACIÓN DEL ACTA', 'EUS-ACEPTACIÓN DEL ACTA')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla52); 
		strSql.append(" ( ").append(W83bMigracionBD.cFase052).append(","); 
		strSql.append(W83bMigracionBD.desCas052).append(","); 
		strSql.append(W83bMigracionBD.desEus052).append(")");  
		strSql.append(" VALUES (4, 'CIERRE MENSUAL', 'EUS-CIERRE MENSUAL')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);	
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla52); 
		strSql.append(" ( ").append(W83bMigracionBD.cFase052).append(","); 
		strSql.append(W83bMigracionBD.desCas052).append(","); 
		strSql.append(W83bMigracionBD.desEus052).append(")");  
		strSql.append(" VALUES (5, 'IMPUGNACION', 'EUS-IMPUGNACION')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla52); 
		strSql.append(" ( ").append(W83bMigracionBD.cFase052).append(","); 
		strSql.append(W83bMigracionBD.desCas052).append(","); 
		strSql.append(W83bMigracionBD.desEus052).append(")"); 
		strSql.append(" VALUES (6, 'INCIDENCIA', 'EUS-INCIDENCIA')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	
	
	/**
	 * Insertar62.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar62() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 62 ----------");
		
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla62); 
		strSql.append(" ( ").append(W83bMigracionBD.cFase052).append(","); 
		strSql.append(W83bMigracionBD.desCas052).append(","); 
		strSql.append(W83bMigracionBD.desEus052).append(")");  
		strSql.append(" VALUES (1, 'TRAMITACIÓN DEL PREAVISO', 'EUS-TRAMITACIÓN DEL PREAVISO')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla62); 
		strSql.append(" ( ").append(W83bMigracionBD.tpIncidencia062).append(","); 
		strSql.append(W83bMigracionBD.descIncid062).append(","); 
		strSql.append(W83bMigracionBD.deseIncid062).append(")"); 
		strSql.append(" VALUES ('1', 'SUSTITUCIÓN', 'EUS_SUSTITUCIÓN')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
				
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla62); 
		strSql.append(" ( ").append(W83bMigracionBD.tpIncidencia062).append(","); 
		strSql.append(W83bMigracionBD.descIncid062).append(","); 
		strSql.append(W83bMigracionBD.deseIncid062).append(")"); 
		strSql.append(" VALUES ('2', 'DIMISIÓN', 'EUS_DIMISIÓN')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}		
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla62);  
		strSql.append(" ( ").append(W83bMigracionBD.tpIncidencia062).append(","); 
		strSql.append(W83bMigracionBD.descIncid062).append(","); 
		strSql.append(W83bMigracionBD.deseIncid062).append(")"); 
		strSql.append(" VALUES ('3', 'BAJA', 'EUS_BAJA')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla62);  
		strSql.append(" ( ").append(W83bMigracionBD.tpIncidencia062).append(","); 
		strSql.append(W83bMigracionBD.descIncid062).append(","); 
		strSql.append(W83bMigracionBD.deseIncid062).append(")"); 
		strSql.append(" VALUES ('4', 'FALLECIMIENTO', 'EUS_FALLECIMIENTO')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla62); 
		strSql.append(" ( ").append(W83bMigracionBD.tpIncidencia062).append(","); 
		strSql.append(W83bMigracionBD.descIncid062).append(","); 
		strSql.append(W83bMigracionBD.deseIncid062).append(")"); 
		strSql.append(" VALUES ('5', 'REVOCACIÓN', 'EUS_REVOCACIÓN')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla62); 
		strSql.append(" ( ").append(W83bMigracionBD.tpIncidencia062).append(","); 
		strSql.append(W83bMigracionBD.descIncid062).append(","); 
		strSql.append(W83bMigracionBD.deseIncid062).append(")"); 
		strSql.append(" VALUES ('6', 'ACTA PARCIAL', 'EUS_ACTA PARCIAL')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla62); 
		strSql.append(" ( ").append(W83bMigracionBD.tpIncidencia062).append(","); 
		strSql.append(W83bMigracionBD.descIncid062).append(","); 
		strSql.append(W83bMigracionBD.deseIncid062).append(")"); 
		strSql.append(" VALUES ('7', 'SUBSANACIÓN', 'EUS_SUBSANACIÓN')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	}
	
	/**
	 * Insertar63.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar63() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 63 ----------");
						
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla63); 
		strSql.append(" ( ").append(W83bMigracionBD.tpSolicit063).append(","); 
		strSql.append(W83bMigracionBD.descSolic063).append(","); 
		strSql.append(W83bMigracionBD.deseSolic063).append(") "); 
		strSql.append(" VALUES (1, 'PRESIDENTE O SECRETARIO DEL COMITÉ DE EMPRESA', 'EUS-PRESIDENTE O SECRETARIO DEL COMITÉ DE EMPRESA')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla63); 
		strSql.append(" ( ").append(W83bMigracionBD.tpSolicit063).append(","); 
		strSql.append(W83bMigracionBD.descSolic063).append(","); 
		strSql.append(W83bMigracionBD.deseSolic063).append(") "); 
		strSql.append(" VALUES (2, 'DELEGADO DE PERSONAL QUE PERMANECE', 'EUS-DELEGADO DE PERSONAL QUE PERMANECE')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}		

		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla63);
		strSql.append(" ( ").append(W83bMigracionBD.tpSolicit063).append(","); 
		strSql.append(W83bMigracionBD.descSolic063).append(","); 
		strSql.append(W83bMigracionBD.deseSolic063).append(") "); 
		strSql.append(" VALUES (3, 'REPRESENTANTE DEL SINDICATO', 'EUS-REPRESENTANTE DEL SINDICATO')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla63);
		strSql.append(" ( ").append(W83bMigracionBD.tpSolicit063).append(","); 
		strSql.append(W83bMigracionBD.descSolic063).append(","); 
		strSql.append(W83bMigracionBD.deseSolic063).append(") "); 
		strSql.append(" VALUES (4, 'EN REPRESENTACIÓN PROPIA', 'EUS-EN REPRESENTACIÓN PROPIA')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	}
	
	
	/**
	 * Insertar75.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar75() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 75 ----------");
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla75); 
		strSql.append(" ( ").append(W83bMigracionBD.idRdo075).append(","); 
		strSql.append(W83bMigracionBD.descRdoCas075).append(","); 
		strSql.append(W83bMigracionBD.descRdoEus075).append(") "); 
		strSql.append(" VALUES (1, 'REGISTRO SÍ', 'EUS-REGISTRO SÍ')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
				
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla75); 
		strSql.append(" ( ").append(W83bMigracionBD.idRdo075).append(","); 
		strSql.append(W83bMigracionBD.descRdoCas075).append(","); 
		strSql.append(W83bMigracionBD.descRdoEus075).append(") "); 
		strSql.append(" VALUES (2, 'REGISTRO NO', 'EUS-REGISTRO NO')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}		

		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	}
	
	/**
	 * Insertar12.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar12() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 12 ----------");
		
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (1, 1, 'RECEPCIÓN DEL PREAVISO Y DOCUMENTACIÓN E INICIO DEL EXPEDIENTE', '*RECEPCIÓN DEL PREAVISO Y DOCUMENTACIÓN E INICIO DEL EXPEDIENTE')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}		
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES ( 2, 1, 'COMUNICACIÓN A SINDICATOS', '*COMUNICACIÓN A SINDICATOS')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (3, 1, 'NOTIFICACIÓN DEL PREAVISO A LA EMPRESA', '*NOTIFICACIÓN DEL PREAVISO A LA EMPRESA')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (1, 2, 'RECEPCIÓN DEL ACTA Y DOCUMENTACIÓN', '*RECEPCIÓN DEL ACTA Y DOCUMENTACIÓN')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (2, 2, 'COMUNICACIÓN A SINDICATOS', '*COMUNICACIÓN A SINDICATOS')"); 
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (4, 1, 'RECEPCIÓN SOLICITUD DE MODIFICACIÓN O APORTACIÓN EXTRA DE INFORMAC', '*RECEPCIÓN SOLICITUD DE MODIFICACIÓN O APORTACIÓN EXTRA DE INFORMACIÓN')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (1, 3, 'REGISTRO DEFINITIVO', '*REGISTRO DEFINITIVO')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (1, 4, 'CIERRE MENSUAL', '*CIERRE MENSUAL')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (2, 6, 'MODIFICACIÓN ACTA POR INCIDENCIA', '*MODIFICACIÓN ACTA POR INCIDENCIA')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (4, 2, 'NOTIFICACIÓN DE REQUERIMIENTO', '*NOTIFICACIÓN DE REQUERIMIENTO')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (5, 2, 'RECEPCIÓN DE LA SUBSANACIÓN', '*RECEPCIÓN DE LA SUBSANACIÓN')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (2, 5, 'COMUNICACIÓN DE RECEPCIÓN DE LA IMPUGNACIÓN', '*COMUNICACIÓN DE RECEPCIÓN DE LA IMPUGNACIÓN')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (3, 5, 'CITACIÓN ARBITRAL', '*CITACIÓN ARBITRAL')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (4, 5, 'RESOLUCIÓN DE LAUDO', '*RESOLUCIÓN DE LAUDO')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (5, 5, 'RELLENAR LAUDO Y NOTIFICAR RESOLUCIÓN', '*RELLENAR LAUDO Y NOTIFICAR RESOLUCIÓN')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (1, 6, 'ALTA INCIDENCIA', '*ALTA INCIDENCIA')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (3, 2, 'NOTIFICAR A LA EMPRESA', '*NOTIFICAR A LA EMPRESA')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (1, 5, 'RECEPCIÓN DE LA IMPUGNACIÓN', '*RECEPCIÓN DE LA IMPUGNACIÓN')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (99, 1, 'SIN ESPECIFICAR', 'EUS-SIN ESPECIFICAR')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (99, 2, 'SIN ESPECIFICAR', 'EUS-SIN ESPECIFICAR')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (99, 3, 'SIN ESPECIFICAR', 'EUS-SIN ESPECIFICAR')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (99, 4, 'SIN ESPECIFICAR', 'EUS-SIN ESPECIFICAR')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (99, 5, 'SIN ESPECIFICAR', 'EUS-SIN ESPECIFICAR')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		
		strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla12); 
		strSql.append(" ( ").append(W83bMigracionBD.codTram012).append(","); 
		strSql.append(W83bMigracionBD.codFase012).append(","); 
		strSql.append(W83bMigracionBD.desCas012).append(","); 
		strSql.append(W83bMigracionBD.desEus012).append(") "); 
		strSql.append(" VALUES (99, 6, 'SIN ESPECIFICAR', 'EUS-SIN ESPECIFICAR')");
		try{
			W83bDataBase.executeTableMovement(strSql.toString(), null,null);
		}
		catch (NamingException e){
			W83bClsTrazas.trazaDebug(null, e+"");
		}
		

		
		
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	}
	
	/**
	 * Insertar13.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar13() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 13 ----------");
		strSql.append("SELECT ").append(W83bMigracionBD.codConv02);
		strSql.append(",").append(W83bMigracionBD.desCas02);
		strSql.append(",").append(W83bMigracionBD.diferencias02);
		strSql.append(",").append(W83bMigracionBD.espAlava02);
		strSql.append(",").append(W83bMigracionBD.espGuip02);
		strSql.append(",").append(W83bMigracionBD.espViz02);
		strSql.append(",").append(W83bMigracionBD.codMadrid02);
		strSql.append(",").append(W83bMigracionBD.tEmpresa02);
		strSql.append(" FROM ").append(W83bMigracionBD.tablad162);		
		
		List lista = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
		W83bMigracionBean registro = new W83bMigracionBean();
		for(int i=0;i<lista.size();i++){
			registro = (W83bMigracionBean)lista.get(i);
			
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla13).append(" (");
			strSql.append(W83bMigracionBD.codConv013).append(",").append(W83bMigracionBD.codEmpr013);
			strSql.append(W83bMigracionBD.sDife013).append(",");
			strSql.append(W83bMigracionBD.sEspAlav013).append(",");
			strSql.append(W83bMigracionBD.sEspGuip013).append(",");
			strSql.append(W83bMigracionBD.sEspViz013).append(",");
			strSql.append(W83bMigracionBD.cMadrid013).append(",");
			strSql.append(W83bMigracionBD.desCas013).append(",");
			strSql.append(W83bMigracionBD.desEus013).append(") ");
			strSql.append(" VALUES (").append(registro.getCodConv02()).append(",");
			strSql.append(registro.getTEmpresa02()).append(",");
			strSql.append(registro.getDiferencias02()).append(",");
			strSql.append(registro.getEspAlava02()).append(",");
			strSql.append(registro.getEspGuip02()).append(",");
			strSql.append(registro.getEspViz02()).append(",");
			strSql.append(registro.getCodMadrid02()).append(",");
			strSql.append(registro.getDesCas02()).append(",");
			strSql.append("EUS-").append(registro.getDesCas02()).append(")");
			
			
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	
	/**
	 * Insertar15.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar15() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 15 ----------");
		strSql.append("SELECT ").append(W83bMigracionBD.codAgrup09);
		strSql.append(",").append(W83bMigracionBD.codConv09);
		strSql.append(" FROM ").append(W83bMigracionBD.tablad169);		
		
		List lista = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
		W83bMigracionBean registro = new W83bMigracionBean();
		for(int i=0;i<lista.size();i++){
			registro = (W83bMigracionBean)lista.get(i);
			
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla15).append(" (");
			strSql.append(W83bMigracionBD.codConv015).append(",").append(W83bMigracionBD.codAgru015);
			strSql.append(") ");
			strSql.append(" VALUES (").append(registro.getCodAgrup09()).append(",");
			strSql.append(registro.getCodConv09()).append(")");
			
			
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	
	/**
	 * Insertar25.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar25() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 25 ----------");
		strSql.append("SELECT ").append(W83bMigracionBD.codTerri14);
		strSql.append(",").append(W83bMigracionBD.anoElec14);
		strSql.append(",").append(W83bMigracionBD.numActa14);
		strSql.append(",").append(W83bMigracionBD.dni14);
		strSql.append(",").append(W83bMigracionBD.nombre14);
		strSql.append(",").append(W83bMigracionBD.ape114);
		strSql.append(",").append(W83bMigracionBD.ape214);
		strSql.append(",").append(W83bMigracionBD.colegio14);
		strSql.append(",").append(W83bMigracionBD.codSindi14);
		strSql.append(",").append(W83bMigracionBD.sexo14);
		strSql.append(",").append(W83bMigracionBD.fAlta14);
		strSql.append(",").append(W83bMigracionBD.fBaja14);
		strSql.append(",").append(W83bMigracionBD.codBaja14);
		strSql.append(",").append(W83bMigracionBD.dniSust14);
		strSql.append(",").append(W83bMigracionBD.usua14);
		strSql.append(",").append(W83bMigracionBD.fActu14);
		strSql.append(" FROM ").append(W83bMigracionBD.tablad1614);		
		
		List lista = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
		W83bMigracionBean registro = new W83bMigracionBean();
		for(int i=0;i<lista.size();i++){
			registro = (W83bMigracionBean)lista.get(i);
			
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla25).append(" (");
			strSql.append(W83bMigracionBD.dni025).append(",").append(W83bMigracionBD.nActa025);
			strSql.append(",").append(W83bMigracionBD.anoActa025).append(",").append(W83bMigracionBD.codTerrit025);
			strSql.append(",").append(W83bMigracionBD.version025).append(",").append(W83bMigracionBD.fBaja025);
			strSql.append(",").append(W83bMigracionBD.codSindi025).append(",").append(W83bMigracionBD.cColeg025);
			strSql.append(",").append(W83bMigracionBD.nombre025).append(",").append(W83bMigracionBD.apel1025);
			strSql.append(",").append(W83bMigracionBD.apel2025).append(",").append(W83bMigracionBD.sexo025);
			strSql.append(",").append(W83bMigracionBD.fAlta025).append(",").append(W83bMigracionBD.dniSust025);
			strSql.append(",").append(W83bMigracionBD.usua025).append(",").append(W83bMigracionBD.cBaja025);
			strSql.append(",").append(W83bMigracionBD.fActu025);
			strSql.append(") ");
			strSql.append(" VALUES (");
			strSql.append(registro.getDni14()).append(",");
			strSql.append(registro.getNumActa14()).append(",");
			strSql.append(registro.getAnoElec14()).append(",");
			strSql.append(registro.getCodTerri14()).append(", 0 ,");
			strSql.append(registro.getFBaja14()).append(",");
			strSql.append(registro.getCodSindi14()).append(",");
			strSql.append(registro.getColegio14()).append(",");
			strSql.append(registro.getNombre14()).append(",");
			strSql.append(registro.getApe114()).append(",");
			strSql.append(registro.getApe214()).append(",");
			strSql.append(registro.getSexo14()).append(",");
			strSql.append(registro.getFAlta14()).append(",");
			strSql.append(registro.getDniSust14()).append(",");
			strSql.append(registro.getUsua14()).append(",");
			strSql.append(registro.getCodBaja14()).append(",");
			strSql.append(registro.getFActu14()).append(")");
		
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	/**
	 * Insertar31.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar31() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 31 ----------");
		strSql.append("SELECT ").append(W83bMigracionBD.cTpVoz24);
		strSql.append(",").append(W83bMigracionBD.codVoz24);
		strSql.append(",").append(W83bMigracionBD.descCas24);
		strSql.append(" FROM ").append(W83bMigracionBD.tablad1624);		
		
		List lista = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
		W83bMigracionBean registro = new W83bMigracionBean();
		for(int i=0;i<lista.size();i++){
			registro = (W83bMigracionBean)lista.get(i);
			
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla31).append(" (");
			strSql.append(W83bMigracionBD.cVoz031).append(",").append(W83bMigracionBD.cTipVoz031);
			strSql.append(",").append(W83bMigracionBD.desCas031).append(",").append(W83bMigracionBD.desEus031);
			strSql.append(") ");
			strSql.append(" VALUES (");
			strSql.append(registro.getCTpVoz24()).append(",");
			strSql.append(registro.getCodVoz24()).append(",");
			strSql.append(registro.getDescCas24()).append(",");
			strSql.append("EUS-").append(registro.getDescCas24()).append(")");
			
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	
	/**
	 * Insertar37.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar37() throws Exception{
		
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 37 ----------");
		StringBuffer strSql = this.getString37();
	
		List lista = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
		W83bMigracionBean registro = new W83bMigracionBean();
		for(int i=0;i<lista.size();i++){
			registro = (W83bMigracionBean)lista.get(i);
		
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla37).append(" (");
			strSql.append(W83bMigracionBD.nPreaviso037).append(",").append(W83bMigracionBD.anoPreaviso037);
			strSql.append(",").append(W83bMigracionBD.cTerrit037).append(",").append(W83bMigracionBD.fEntra037);
			strSql.append(",").append(W83bMigracionBD.cConv037).append(",").append(W83bMigracionBD.idCentro037);
			strSql.append(",").append(W83bMigracionBD.fInicio037).append(",").append(W83bMigracionBD.sParcial037);
			strSql.append(",").append(W83bMigracionBD.global037).append(",").append(W83bMigracionBD.admonEmp037);
			strSql.append(",").append(W83bMigracionBD.fElecc037).append(",").append(W83bMigracionBD.fRegis037);
			strSql.append(",").append(W83bMigracionBD.nRegis037).append(",").append(W83bMigracionBD.anoActa037);
			strSql.append(",").append(W83bMigracionBD.nActa037).append(",").append(W83bMigracionBD.observ037);
			strSql.append(",").append(W83bMigracionBD.usua037).append(",").append(W83bMigracionBD.fActu037);
			strSql.append(",").append(W83bMigracionBD.nCenafec037);
			strSql.append(",").append(W83bMigracionBD.fEnvio037).append(",").append(W83bMigracionBD.usuEnv037);
			strSql.append(",").append(W83bMigracionBD.ncarpprocelec037).append(",").append(W83bMigracionBD.oid8501037);
			strSql.append(",").append(W83bMigracionBD.nop037).append(",").append(W83bMigracionBD.ndf037);
			strSql.append(") ");
			strSql.append(" VALUES (");
			strSql.append(registro.getNumPreav10()).append(",");
			strSql.append(registro.getAnoElec10()).append(",");
			strSql.append(registro.getCodTerrit10()).append(",");
			strSql.append(registro.getFEntrada10()).append(",");
			strSql.append(registro.getConvAcu10()).append(",");			
			strSql.append(registro.getCodCentro10()).append(",");			
			strSql.append(registro.getFInicio10()).append(",");
			strSql.append(registro.getParcial10()).append(",");
			strSql.append(registro.getGlobal10()).append(",");
			strSql.append(registro.getAdmEmpr10()).append(",");			
			strSql.append(registro.getFElec10()).append(",");			
			strSql.append(registro.getFRegis10()).append(",");
			strSql.append(registro.getNumREgis10()).append(",");
			strSql.append(registro.getAnoActa10()).append(",");
			strSql.append(registro.getNumActa10()).append(",");			
			strSql.append(registro.getObserv10()).append(",");
			strSql.append(registro.getUsua10()).append(",");
			strSql.append(registro.getFActu10()).append(",");
			strSql.append(registro.getNumCena10()).append(",");
			strSql.append(registro.getFEnvio10()).append(",");
			strSql.append(registro.getUsuEnvio10()).append(",");
			strSql.append(registro.getNCarpeta10()).append(",");
			strSql.append(registro.getOid10()).append(",");
			strSql.append(registro.getNumOp10()).append(",");
			strSql.append(registro.getNumDf10()).append(")");
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
			
			if(!("").equals(registro.getCodSindi110()) && registro.getCodSindi110()!=null){
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla27).append(" (");
				strSql.append(W83bMigracionBD.numPreaviso027).append(",").append(W83bMigracionBD.anoPreaviso027);
				strSql.append(W83bMigracionBD.cTerrit027).append(",").append(W83bMigracionBD.cSindi027);
				strSql.append(") ").append(" VALUES (");
				strSql.append(registro.getNumPreav10()).append(",");
				strSql.append(registro.getAnoElec10()).append(",");
				strSql.append(registro.getCodTerrit10()).append(",");
				strSql.append(registro.getCodSindi110()).append(")");
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}
			if(!("").equals(registro.getCodSindi210()) && registro.getCodSindi210()!=null){
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla27).append(" (");
				strSql.append(W83bMigracionBD.numPreaviso027).append(",").append(W83bMigracionBD.anoPreaviso027);
				strSql.append(W83bMigracionBD.cTerrit027).append(",").append(W83bMigracionBD.cSindi027);
				strSql.append(") ").append(" VALUES (");
				strSql.append(registro.getNumPreav10()).append(",");
				strSql.append(registro.getAnoElec10()).append(",");
				strSql.append(registro.getCodTerrit10()).append(",");
				strSql.append(registro.getCodSindi210()).append(")");
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}
			if(!("").equals(registro.getCodSindi310()) && registro.getCodSindi310()!=null){
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla27).append(" (");
				strSql.append(W83bMigracionBD.numPreaviso027).append(",").append(W83bMigracionBD.anoPreaviso027);
				strSql.append(W83bMigracionBD.cTerrit027).append(",").append(W83bMigracionBD.cSindi027);
				strSql.append(") ").append(" VALUES (");
				strSql.append(registro.getNumPreav10()).append(",");
				strSql.append(registro.getAnoElec10()).append(",");
				strSql.append(registro.getCodTerrit10()).append(",");
				strSql.append(registro.getCodSindi310()).append(")");
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}
			if(!("").equals(registro.getCodSindi410()) && registro.getCodSindi410()!=null){
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla27).append(" (");
				strSql.append(W83bMigracionBD.numPreaviso027).append(",").append(W83bMigracionBD.anoPreaviso027);
				strSql.append(W83bMigracionBD.cTerrit027).append(",").append(W83bMigracionBD.cSindi027);
				strSql.append(") ").append(" VALUES (");
				strSql.append(registro.getNumPreav10()).append(",");
				strSql.append(registro.getAnoElec10()).append(",");
				strSql.append(registro.getCodTerrit10()).append(",");
				strSql.append(registro.getCodSindi410()).append(")");
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}
		
			
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	
	
	private StringBuffer getString37(){
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		
		strSql.append("SELECT ").append(W83bMigracionBD.codTerrit10);
		strSql.append(",").append(W83bMigracionBD.anoElec10).append(",").append(W83bMigracionBD.numPreav10);
		strSql.append(",").append(W83bMigracionBD.codCentro10).append(",").append(W83bMigracionBD.fEntrada10);
		strSql.append(",").append(W83bMigracionBD.fInicio10).append(",").append(W83bMigracionBD.fElec10);
		strSql.append(",").append(W83bMigracionBD.fRegis10).append(",").append(W83bMigracionBD.numREgis10);
		strSql.append(",").append(W83bMigracionBD.anoActa10).append(",").append(W83bMigracionBD.numActa10);
		strSql.append(",").append(W83bMigracionBD.parcial10).append(",").append(W83bMigracionBD.global10);
		strSql.append(",").append(W83bMigracionBD.codSindi110).append(",").append(W83bMigracionBD.codSindi210);
		strSql.append(",").append(W83bMigracionBD.codSindi310).append(",").append(W83bMigracionBD.codSindi410);
		strSql.append(",").append(W83bMigracionBD.observ10).append(",").append(W83bMigracionBD.usua10);
		strSql.append(",").append(W83bMigracionBD.fActu10).append(",").append(W83bMigracionBD.convAcu10);
		strSql.append(",").append(W83bMigracionBD.admEmpr10).append(",").append(W83bMigracionBD.numCena10);
		strSql.append(",").append(W83bMigracionBD.fEnvio10).append(",").append(W83bMigracionBD.usuEnvio10);
		strSql.append(",").append(W83bMigracionBD.nCarpeta10).append(",").append(W83bMigracionBD.oid10);
		strSql.append(",").append(W83bMigracionBD.numOp10).append(",").append(W83bMigracionBD.numDf10);
		strSql.append(" FROM ").append(W83bMigracionBD.tablad1610);		
		
		return strSql;
	}
	
	/**
	 * Insertar53.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar53() throws Exception{

		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 53 ----------");
		StringBuffer strSql = this.getString37();
		
		List lista = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
		W83bMigracionBean registro = new W83bMigracionBean();
		for(int i=0;i<lista.size();i++){
			registro = (W83bMigracionBean)lista.get(i);
			
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("SELECT ").append(W83bMigracionBD.cifJ73).append(",");
			strSql.append(W83bMigracionBD.razSocialJ73).append(",");
			strSql.append(W83bMigracionBD.numCentroJ73).append(" FROM ");
			strSql.append(W83bMigracionBD.tablaJ73).append(" WHERE ");
			strSql.append(W83bMigracionBD.codCentroJ73).append(" = ");
			strSql.append(registro.getCodCentro10());
			List centro = new ArrayList();//NOPMD
			try{
				centro = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
			W83bMigracionBean elCentro = new W83bMigracionBean();//NOPMD
			if(centro.size()>0){
				elCentro = (W83bMigracionBean)centro.get(0);
			}
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla53).append(" (");
			strSql.append(W83bMigracionBD.numPreaviso053).append(",").append(W83bMigracionBD.anoPreaviso053);
			strSql.append(",").append(W83bMigracionBD.cTerrit053);
			strSql.append(",").append(W83bMigracionBD.codConv053).append(",").append(W83bMigracionBD.fInicio053);
			strSql.append(",").append(W83bMigracionBD.fElecc053).append(",").append(W83bMigracionBD.sParcial053);
			strSql.append(",").append(W83bMigracionBD.global053).append(",").append(W83bMigracionBD.observ053);
			strSql.append(",").append(W83bMigracionBD.usuario053).append(",").append(W83bMigracionBD.fActu053);
			strSql.append(",").append(W83bMigracionBD.convAcu053).append(",").append(W83bMigracionBD.admEmpr053);
			strSql.append(",").append(W83bMigracionBD.numCena053).append(",").append(W83bMigracionBD.fEnvio053);
			strSql.append(",").append(W83bMigracionBD.usuEnv053).append(",").append(W83bMigracionBD.nCarpeta053);
			strSql.append(",").append(W83bMigracionBD.oid053);
			strSql.append(",").append(W83bMigracionBD.nOp053).append(",").append(W83bMigracionBD.nDf053);
			strSql.append(",").append(W83bMigracionBD.nifCentro053).append(",").append(W83bMigracionBD.numCentro053);
			strSql.append(",").append(W83bMigracionBD.razSocial053);
			strSql.append(") ");
			strSql.append(" VALUES (");
			strSql.append(registro.getNumPreav10()).append(",");
			strSql.append(registro.getAnoElec10()).append(",");
			strSql.append(registro.getCodTerrit10()).append(",");
			strSql.append(registro.getFElec10()).append(",");	
			strSql.append(registro.getParcial10()).append(",");
			strSql.append(registro.getGlobal10()).append(",");
			strSql.append(registro.getObserv10()).append(",");
			strSql.append(registro.getUsua10()).append(",");
			strSql.append(registro.getFActu10()).append(",");
			strSql.append(registro.getConvAcu10()).append(",");	
			strSql.append(registro.getAdmEmpr10()).append(",");		
			strSql.append(registro.getNumCena10()).append(",");
			strSql.append(registro.getFEnvio10()).append(",");
			strSql.append(registro.getUsuEnvio10()).append(",");
			strSql.append(registro.getNCarpeta10()).append(",");
			strSql.append(registro.getOid10()).append(",");
			strSql.append(registro.getNumOp10()).append(",");
			strSql.append(registro.getNumDf10()).append(",");			
			strSql.append(elCentro.getCifJ73()).append(",");
			strSql.append(elCentro.getNumCentroJ73()).append(",");
			strSql.append(elCentro.getRazSocialJ73()).append(")");
					
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
			
			if(!("").equals(registro.getCodSindi110()) && registro.getCodSindi110()!=null){
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla54).append(" (");
				strSql.append(W83bMigracionBD.numPreaviso054).append(",").append(W83bMigracionBD.anoPreaviso054);
				strSql.append(W83bMigracionBD.cTerrit054).append(",").append(W83bMigracionBD.cSindi054);
				strSql.append(") ").append(" VALUES (");
				strSql.append(registro.getNumPreav10()).append(",");
				strSql.append(registro.getAnoElec10()).append(",");
				strSql.append(registro.getCodTerrit10()).append(",");
				strSql.append(registro.getCodSindi110()).append(")");
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}
			if(!("").equals(registro.getCodSindi210()) && registro.getCodSindi210()!=null){
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla54).append(" (");
				strSql.append(W83bMigracionBD.numPreaviso054).append(",").append(W83bMigracionBD.anoPreaviso054);
				strSql.append(W83bMigracionBD.cTerrit054).append(",").append(W83bMigracionBD.cSindi054);
				strSql.append(") ").append(" VALUES (");
				strSql.append(registro.getNumPreav10()).append(",");
				strSql.append(registro.getAnoElec10()).append(",");
				strSql.append(registro.getCodTerrit10()).append(",");
				strSql.append(registro.getCodSindi210()).append(")");
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}
			if(!("").equals(registro.getCodSindi310()) && registro.getCodSindi310()!=null){
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla54).append(" (");
				strSql.append(W83bMigracionBD.numPreaviso054).append(",").append(W83bMigracionBD.anoPreaviso054);
				strSql.append(W83bMigracionBD.cTerrit054).append(",").append(W83bMigracionBD.cSindi054);
				strSql.append(") ").append(" VALUES (");
				strSql.append(registro.getNumPreav10()).append(",");
				strSql.append(registro.getAnoElec10()).append(",");
				strSql.append(registro.getCodTerrit10()).append(",");
				strSql.append(registro.getCodSindi310()).append(")");
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}
			if(!("").equals(registro.getCodSindi410()) && registro.getCodSindi410()!=null){
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla54).append(" (");
				strSql.append(W83bMigracionBD.numPreaviso054).append(",").append(W83bMigracionBD.anoPreaviso054);
				strSql.append(W83bMigracionBD.cTerrit054).append(",").append(W83bMigracionBD.cSindi054);
				strSql.append(") ").append(" VALUES (");
				strSql.append(registro.getNumPreav10()).append(",");
				strSql.append(registro.getAnoElec10()).append(",");
				strSql.append(registro.getCodTerrit10()).append(",");
				strSql.append(registro.getCodSindi410()).append(")");
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}
			
			
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	
	
	/* Insertar16.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar16() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 16 ----------");
		strSql.append("SELECT ").append(W83bMigracionBD.codTerrit11);
		strSql.append(",").append(W83bMigracionBD.anoElec11).append(",").append(W83bMigracionBD.numActa11);
		strSql.append(",").append(W83bMigracionBD.codCentro11).append(",").append(W83bMigracionBD.anoActaTot11);
		strSql.append(",").append(W83bMigracionBD.numActaTot11).append(",").append(W83bMigracionBD.numReg11);
		strSql.append(",").append(W83bMigracionBD.fReg11).append(",").append(W83bMigracionBD.anoRegDef11);
		strSql.append(",").append(W83bMigracionBD.numRegDef11).append(",").append(W83bMigracionBD.fRegDef11);
		strSql.append(",").append(W83bMigracionBD.anoPreav11);
		strSql.append(",").append(W83bMigracionBD.numPreav11).append(",").append(W83bMigracionBD.fEntrada11);
		strSql.append(",").append(W83bMigracionBD.fElec11).append(",").append(W83bMigracionBD.fComision11);
		strSql.append(",").append(W83bMigracionBD.fBaja11).append(",").append(W83bMigracionBD.codBaja11);
		strSql.append(",").append(W83bMigracionBD.elecH11).append(",").append(W83bMigracionBD.elecM11);
		strSql.append(",").append(W83bMigracionBD.totElec11).append(",").append(W83bMigracionBD.candH11);
		strSql.append(",").append(W83bMigracionBD.candM11).append(",").append(W83bMigracionBD.papVal111);
		strSql.append(",").append(W83bMigracionBD.papVal211).append(",").append(W83bMigracionBD.papNul111);
		strSql.append(",").append(W83bMigracionBD.papNul211).append(",").append(W83bMigracionBD.papBlan111);
		strSql.append(",").append(W83bMigracionBD.papBlan211).append(",").append(W83bMigracionBD.elec111);
		strSql.append(",").append(W83bMigracionBD.elec211).append(",").append(W83bMigracionBD.vota111);
		strSql.append(",").append(W83bMigracionBD.vota211).append(",");
		strSql.append(",").append(W83bMigracionBD.observ11).append(",").append(W83bMigracionBD.usua11);
		strSql.append(",").append(W83bMigracionBD.fActu11).append(",").append(W83bMigracionBD.inspec11);
		strSql.append(",").append(W83bMigracionBD.remite11).append(",").append(W83bMigracionBD.remiteImp11);
		strSql.append(" FROM ").append(W83bMigracionBD.tablad1611);		
	
		List lista = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
		W83bMigracionBean registro = new W83bMigracionBean();
		int delegadosTotal = 0;
		for(int i=0;i<lista.size();i++){
			registro = (W83bMigracionBean)lista.get(i);
			
			Integer totalElec = Integer.valueOf(registro.getTotElec11());
			String tipoConvenio = "O";
			if(registro.getCodConv11().startsWith("9")){
				tipoConvenio = "A";
			}
			if(totalElec.intValue()>1001){
				totalElec = Integer.valueOf("1000");
				//si el convenio empieza por 9, es de administracion
				
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				strSql.append("SELECT ").append(W83bMigracionBD.numDeleg021).append(" FROM ");
				strSql.append(W83bMigracionBD.tabla21).append(" WHERE ");
				strSql.append(registro.getTotElec11()).append(" BETWEEN ");
				strSql.append(W83bMigracionBD.trabDesde021).append(" AND ");
				strSql.append(W83bMigracionBD.trabHasta021).append(" AND ");
				strSql.append(W83bMigracionBD.tpConv021).append(" = ").append(tipoConvenio);
				List delegados = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
				
				W83bMigracionBean delegado = (W83bMigracionBean)delegados.get(0);
				//sacamos el num que se ha metido
                int numDelegados=Integer.parseInt(delegado.getNumDeleg021());
                int miles=totalElec.intValue()/1000;
                delegadosTotal=numDelegados+(miles*2);
                
            }else{
            	strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				strSql.append("SELECT ").append(W83bMigracionBD.numDeleg021).append(" FROM ");
				strSql.append(W83bMigracionBD.tabla21).append(" WHERE ");
				strSql.append(registro.getTotElec11()).append(" BETWEEN ");
				strSql.append(W83bMigracionBD.trabDesde021).append(" AND ");
				strSql.append(W83bMigracionBD.trabHasta021).append(" AND ");
				strSql.append(W83bMigracionBD.tpConv021).append(" = ").append(tipoConvenio);
				List delegados = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
				
				W83bMigracionBean delegado = (W83bMigracionBean)delegados.get(0);
				delegadosTotal = Integer.parseInt(delegado.getNumDeleg021());
			}
			
			
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla16).append(" (");
			strSql.append(W83bMigracionBD.numActa016).append(",").append(W83bMigracionBD.anoActa016);
			strSql.append(",").append(W83bMigracionBD.cTerrit016).append(",").append(W83bMigracionBD.version016);
			strSql.append(",").append(W83bMigracionBD.numPreav016).append(",").append(W83bMigracionBD.anoPreav016);
			strSql.append(",").append(W83bMigracionBD.codConv016).append(",").append(W83bMigracionBD.idCentro016);
			strSql.append(",").append(W83bMigracionBD.codBaja016).append(",").append(W83bMigracionBD.fEntrad016);
			strSql.append(",").append(W83bMigracionBD.fElecc016).append(",").append(W83bMigracionBD.totElec016);
			strSql.append(",").append(W83bMigracionBD.candH016).append(",").append(W83bMigracionBD.candM016);
			strSql.append(",").append(W83bMigracionBD.anoActTot016).append(",").append(W83bMigracionBD.numReg016);
			strSql.append(",").append(W83bMigracionBD.fRegLib016).append(",").append(W83bMigracionBD.anoActTot016).append(",").append(W83bMigracionBD.anoRegDef016);
			strSql.append(",").append(W83bMigracionBD.numRegDef016).append(",").append(W83bMigracionBD.fRegDef016);
			strSql.append(",").append(W83bMigracionBD.fComis016).append(",").append(W83bMigracionBD.fBaja016);
			strSql.append(",").append(W83bMigracionBD.elecH016).append(",").append(W83bMigracionBD.elecM016);
			strSql.append(",").append(W83bMigracionBD.observ016).append(",").append(W83bMigracionBD.usua016);
			strSql.append(",").append(W83bMigracionBD.fActu016).append(",").append(W83bMigracionBD.inspecc016);
			strSql.append(",").append(W83bMigracionBD.validada016).append(",").append(W83bMigracionBD.remite016);
			strSql.append(",").append(W83bMigracionBD.maxDel016).append(") ");
			strSql.append(" VALUES (");
			strSql.append(registro.getNumActa11()).append(",").append(registro.getAnoElec11()).append(",");
			strSql.append(registro.getCodTerrit11()).append(", '0', ").append(registro.getNumPreav11()).append(",");
			strSql.append(registro.getAnoPreav11()).append(",").append(registro.getCodConv11()).append(",");
			strSql.append(registro.getCodCentro11()).append(",").append(registro.getCodBaja11()).append(",");
			strSql.append(registro.getFEntrada11()).append(",").append(registro.getFElec11()).append(",");
			strSql.append(registro.getTotElec11()).append(",").append(registro.getCandH11()).append(",");
			strSql.append(registro.getCandM11()).append(",").append(registro.getAnoActaTot11()).append(",");
			strSql.append(registro.getNumReg11()).append(",").append(registro.getFReg11()).append(",");
			strSql.append(registro.getNumActaTot11()).append(",").append(registro.getAnoRegDef11()).append(",");
			strSql.append(registro.getNumRegDef11()).append(",").append(registro.getFRegDef11()).append(",");
			strSql.append(registro.getFComision11()).append(",").append(registro.getFBaja11()).append(",");
			strSql.append(registro.getElecH11()).append(",").append(registro.getElecM11()).append(",");
			strSql.append(registro.getObserv11()).append(",").append(registro.getUsua11()).append(",");
			strSql.append(registro.getFActu11()).append(",").append(registro.getInspec11()).append(", '1', ");
			strSql.append(registro.getRemite11()).append(",").append(String.valueOf(delegadosTotal)).append(")");
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
			
			
			if(!("").equals(registro.getPapVal111()) && registro.getPapVal111()!=null){
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla44).append(" (");
				strSql.append(W83bMigracionBD.numActa44).append(",").append(W83bMigracionBD.anoActa44);
				strSql.append(W83bMigracionBD.cTerrit44).append(",").append(W83bMigracionBD.version44);
				strSql.append(W83bMigracionBD.codColeg44).append(",").append(W83bMigracionBD.papVal44);
				strSql.append(W83bMigracionBD.papNul44).append(",").append(W83bMigracionBD.papBlanc44);
				strSql.append(W83bMigracionBD.elec44).append(",").append(W83bMigracionBD.vota44);
				strSql.append(") ").append(" VALUES (");
				strSql.append(registro.getNumActa11()).append(",");
				strSql.append(registro.getAnoElec11()).append(",");
				strSql.append(registro.getCodTerrit11()).append(", '0', '0', ");
				strSql.append(registro.getPapVal111()).append(",");
				strSql.append(registro.getPapNul111()).append(",");
				strSql.append(registro.getPapBlan111()).append(",");
				strSql.append(registro.getElec111()).append(",");
				strSql.append(registro.getVota111()).append(")");
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}
		
			if(!("").equals(registro.getPapVal211()) && registro.getPapVal211()!=null){
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla44).append(" (");
				strSql.append(W83bMigracionBD.numActa44).append(",").append(W83bMigracionBD.anoActa44);
				strSql.append(W83bMigracionBD.cTerrit44).append(",").append(W83bMigracionBD.version44);
				strSql.append(W83bMigracionBD.codColeg44).append(",").append(W83bMigracionBD.papVal44);
				strSql.append(W83bMigracionBD.papNul44).append(",").append(W83bMigracionBD.papBlanc44);
				strSql.append(W83bMigracionBD.elec44).append(",").append(W83bMigracionBD.vota44);
				strSql.append(") ").append(" VALUES (");
				strSql.append(registro.getNumActa11()).append(",");
				strSql.append(registro.getAnoElec11()).append(",");
				strSql.append(registro.getCodTerrit11()).append(", '0', '0', ");
				strSql.append(registro.getPapVal211()).append(",");
				strSql.append(registro.getPapNul211()).append(",");
				strSql.append(registro.getPapBlan211()).append(",");
				strSql.append(registro.getElec211()).append(",");
				strSql.append(registro.getVota211()).append(")");
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}
			
			
			
			
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	
	/**
	 * Insertar18.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar18() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 18 ----------");
		strSql.append("SELECT ").append(W83bMigracionBD.codTerrit13);
		strSql.append(",").append(W83bMigracionBD.anoElec13).append(",").append(W83bMigracionBD.numActa13);
		strSql.append(",").append(W83bMigracionBD.codColegio13).append(",").append(W83bMigracionBD.codSindi13);
		strSql.append(",").append(W83bMigracionBD.numDelH13).append(",").append(W83bMigracionBD.numDelM13);
		strSql.append(",").append(W83bMigracionBD.usua13).append(",").append(W83bMigracionBD.fActu13);
		strSql.append(" FROM ").append(W83bMigracionBD.tablad1613);		
				
		List lista = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
		W83bMigracionBean registro = new W83bMigracionBean();
		for(int i=0;i<lista.size();i++){
			registro = (W83bMigracionBean)lista.get(i);
			
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla18).append(" (");
			strSql.append(W83bMigracionBD.numActa18).append(",").append(W83bMigracionBD.anoActa18);
			strSql.append(",").append(W83bMigracionBD.cTerrit18).append(",").append(W83bMigracionBD.verson18);
			strSql.append(",").append(W83bMigracionBD.codColeg18).append(",").append(W83bMigracionBD.codSindi18);
			strSql.append(",").append(W83bMigracionBD.numDelH18).append(",").append(W83bMigracionBD.numDelM18);
			strSql.append(",").append(W83bMigracionBD.usua18).append(",").append(W83bMigracionBD.fActu18);
			strSql.append(") ");
			strSql.append(" VALUES (");
			strSql.append(registro.getNumActa13()).append(",").append(registro.getAnoElec13()).append(",");
			strSql.append(registro.getCodTerrit13()).append(", '0', ").append(registro.getCodColegio13()).append(",");
			strSql.append(registro.getCodSindi13()).append(",").append(registro.getNumDelH13()).append(",");
			strSql.append(registro.getNumDelM13()).append(",").append(registro.getUsua13()).append(",");
			strSql.append(registro.getFActu13()).append(")");
			
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	
	/**
	 * Insertar24.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar24() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 24 ----------");
		strSql.append("SELECT ").append(W83bMigracionBD.codTerrit12);
		strSql.append(",").append(W83bMigracionBD.anoElec12).append(",").append(W83bMigracionBD.numActa12);
		strSql.append(",").append(W83bMigracionBD.codColegio12).append(",").append(W83bMigracionBD.codSindi12);
		strSql.append(",").append(W83bMigracionBD.numDelH12).append(",").append(W83bMigracionBD.numDelM12);
		strSql.append(",").append(W83bMigracionBD.numVotos12).append(",").append(W83bMigracionBD.usua12);
		strSql.append(",").append(W83bMigracionBD.fActu12);
		strSql.append(" FROM ").append(W83bMigracionBD.tablad1612);		
		
		List lista = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
		W83bMigracionBean registro = new W83bMigracionBean();
		for(int i=0;i<lista.size();i++){
			registro = (W83bMigracionBean)lista.get(i);
			
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla24).append(" (");
			strSql.append(W83bMigracionBD.numActa24).append(",").append(W83bMigracionBD.anoActa24);
			strSql.append(",").append(W83bMigracionBD.codTerrit24).append(",").append(W83bMigracionBD.version24);
			strSql.append(",").append(W83bMigracionBD.codColeg24).append(",").append(W83bMigracionBD.codSindi24);
			strSql.append(",").append(W83bMigracionBD.numDelH24).append(",").append(W83bMigracionBD.numDelM24);
			strSql.append(",").append(W83bMigracionBD.numVotos24).append(",").append(W83bMigracionBD.usua24);
			strSql.append(",").append(W83bMigracionBD.fActa24);
			strSql.append(") ");
			strSql.append(" VALUES (");
			strSql.append(registro.getNumActa12()).append(",").append(registro.getAnoElec12()).append(",");
			strSql.append(registro.getCodTerrit12()).append(", '0', ").append(registro.getCodColegio12()).append(",");
			strSql.append(registro.getCodSindi12()).append(",").append(registro.getNumDelH12()).append(",");
			strSql.append(registro.getNumDelM12()).append(",").append(registro.getNumVotos12()).append(",");
			strSql.append(registro.getUsua12()).append(",").append(registro.getFActu12()).append(")");
			
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	
	/**
	 * Insertar33.
	 * 
	 * @throws Exception the exception
	 */
	private void insertar33() throws Exception{
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);
		W83bClsTrazas.trazaDebug(null, "---------- INSERTA LA 33 ----------");
		strSql.append("SELECT ").append(W83bMigracionBD.codTerrit15);
		strSql.append(",").append(W83bMigracionBD.anoImpug15).append(",").append(W83bMigracionBD.numImpug15);
		strSql.append(",").append(W83bMigracionBD.anoPreav15).append(",").append(W83bMigracionBD.numPreav15);
		strSql.append(",").append(W83bMigracionBD.anoActa15).append(",").append(W83bMigracionBD.numActa15);
		strSql.append(",").append(W83bMigracionBD.fImpug15).append(",").append(W83bMigracionBD.empresa15);
		strSql.append(",").append(W83bMigracionBD.codSindi115).append(",").append(W83bMigracionBD.codSindi215);
		strSql.append(",").append(W83bMigracionBD.codSindi315).append(",").append(W83bMigracionBD.codSindi415);
		strSql.append(",").append(W83bMigracionBD.dniArb15).append(",").append(W83bMigracionBD.fEnvioArb15);
		strSql.append(",").append(W83bMigracionBD.fBAjaDEs15).append(",").append(W83bMigracionBD.fEnvioJuz15);
		strSql.append(",").append(W83bMigracionBD.anoLaudo15).append(",").append(W83bMigracionBD.numLaudo15);
		strSql.append(",").append(W83bMigracionBD.fLaudo15).append(",").append(W83bMigracionBD.fSentec15);
		strSql.append(",").append(W83bMigracionBD.asunto15).append(",").append(W83bMigracionBD.decision15);
		strSql.append(",").append(W83bMigracionBD.usua15).append(",").append(W83bMigracionBD.fActu15);
		strSql.append(",").append(W83bMigracionBD.voz115).append(",").append(W83bMigracionBD.voz215);
		strSql.append(",").append(W83bMigracionBD.voz315).append(",").append(W83bMigracionBD.voz415);
		strSql.append(",").append(W83bMigracionBD.voz515).append(",").append(W83bMigracionBD.sino115);
		strSql.append(",").append(W83bMigracionBD.sino215).append(",").append(W83bMigracionBD.sino315);
		strSql.append(",").append(W83bMigracionBD.sino415).append(",").append(W83bMigracionBD.sino515);
		strSql.append(",").append(W83bMigracionBD.textoLaudo15).append(",").append(W83bMigracionBD.cTVoz115);
		strSql.append(",").append(W83bMigracionBD.cTVoz215).append(",").append(W83bMigracionBD.cTVoz315);
		strSql.append(",").append(W83bMigracionBD.cTVoz415).append(",").append(W83bMigracionBD.cTVoz515);
		strSql.append(",").append(W83bMigracionBD.numReg15).append(",").append(W83bMigracionBD.fReg15);
		strSql.append(",").append(W83bMigracionBD.result15);
		strSql.append(" FROM ").append(W83bMigracionBD.tablad1615);		
		
		
		List lista = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
		W83bMigracionBean registro = new W83bMigracionBean();
		for(int i=0;i<lista.size();i++){
			registro = (W83bMigracionBean)lista.get(i);
			String codigoImpug ="";
			if("E".equals(registro.getEmpresa15())){
				codigoImpug = "1";
			}else{
				codigoImpug = "2";
			}
			
			String resultado ="";
			if("A".equals(registro.getResult15())){
				resultado = "1";
			}else if("R".equals(registro.getResult15())){
				resultado = "2";				
			}
			
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla33).append(" (");
			strSql.append(W83bMigracionBD.anoImpugn33).append(",").append(W83bMigracionBD.numImpugn33);
			strSql.append(",").append(W83bMigracionBD.codTerrir33).append(",").append(W83bMigracionBD.fImpug33);
			strSql.append(",").append(W83bMigracionBD.numPreav33).append(",").append(W83bMigracionBD.anoPreav33);
			strSql.append(",").append(W83bMigracionBD.numActa33).append(",").append(W83bMigracionBD.anoActa33);
			strSql.append(",").append(W83bMigracionBD.version33).append(",").append(W83bMigracionBD.dni33);
			strSql.append(",").append(W83bMigracionBD.codImpg33).append(",").append(W83bMigracionBD.fEnvArb33);
			strSql.append(",").append(W83bMigracionBD.fDesed33).append(",").append(W83bMigracionBD.fEnvJuz33);
			strSql.append(",").append(W83bMigracionBD.fSentec33).append(",").append(W83bMigracionBD.asunto33);
			strSql.append(",").append(W83bMigracionBD.decision33).append(",").append(W83bMigracionBD.usua33);
			strSql.append(",").append(W83bMigracionBD.fActu33).append(",").append(W83bMigracionBD.textoLau33);
			strSql.append(",").append(W83bMigracionBD.numRegis33).append(",").append(W83bMigracionBD.fRegis33);
			strSql.append(") ");
			strSql.append(" VALUES (");
			strSql.append(registro.getAnoImpug15()).append(",").append(registro.getNumImpug15()).append(",");
			strSql.append(registro.getCodTerrit15()).append(",").append(registro.getFImpug15()).append(",");
			strSql.append(registro.getNumPreav15()).append(",").append(registro.getAnoPreav15()).append(",");
			strSql.append(registro.getNumActa15()).append(",").append(registro.getAnoActa15()).append(",'0',");
			strSql.append(registro.getDniArb15()).append(",").append(codigoImpug).append(",");
			strSql.append(registro.getFEnvioArb15()).append(",").append(registro.getFBAjaDEs15()).append(",");
			strSql.append(registro.getFEnvioJuz15()).append(",").append(registro.getFSentec15()).append(",");
			strSql.append(registro.getAsunto15()).append(",").append(registro.getDecision15()).append(",");
			strSql.append(registro.getUsua15()).append(",").append(registro.getFActu15()).append(",");
			strSql.append(registro.getTextoLaudo15()).append(",").append(registro.getNumReg15()).append(",");
			strSql.append(registro.getFReg15()).append(")");
		
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
			
			
			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla68).append(" (");
			strSql.append(W83bMigracionBD.numLaudo68).append(",").append(W83bMigracionBD.anoLaudo68);
			strSql.append(",").append(W83bMigracionBD.codTerri68).append(",").append(W83bMigracionBD.anoImpug68);
			strSql.append(",").append(W83bMigracionBD.numImpug68).append(",").append(W83bMigracionBD.fLaudo68);
			strSql.append(",").append(W83bMigracionBD.rdoLaudo68);
			strSql.append(") ");
			strSql.append(" VALUES (");
			strSql.append(registro.getNumLaudo15()).append(",").append(registro.getAnoLaudo15()).append(",");
			strSql.append(registro.getCodTerrit15()).append(",").append(registro.getAnoImpug15()).append(",");
			strSql.append(registro.getNumImpug15()).append(",").append(registro.getFLaudo15()).append(",");
			strSql.append(resultado).append(")");
		
			try{
				W83bDataBase.executeTableMovement(strSql.toString(), null,null);
			}
			catch (NamingException e){
				W83bClsTrazas.trazaDebug(null, e+"");
			}
			
			if(registro.getCTVoz115()!=null && !("").equals(registro.getCTVoz115())){
				
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				/*strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla34).append(" (");
				strSql.append(W83bMigracionBD.numImpug34).append(",").append(W83bMigracionBD.anoImpug34);
				strSql.append(",").append(W83bMigracionBD.codTerrit34).append(",").append(W83bMigracionBD.numLaudo34);
				strSql.append(",").append(W83bMigracionBD.anoLaudo34).append(",").append(W83bMigracionBD.codVoz34);
				strSql.append(",").append(W83bMigracionBD.codTpVoz34).append(",").append(W83bMigracionBD.sino34);
				strSql.append(") ");
				strSql.append(" VALUES (");
				strSql.append(registro.getNumImpug15()).append(",").append(registro.getAnoImpug15()).append(",");
				strSql.append(registro.getCodTerrit15()).append(",").append(registro.getNumLaudo15()).append(",");*/
				strSql = this.stringTabla34(registro);
				strSql.append(registro.getAnoLaudo15()).append(",").append(registro.getVoz115()).append(",");
				strSql.append(registro.getCTVoz115()).append(",").append(registro.getSino115()).append(")");
				
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}
			if(registro.getCTVoz215()!=null && !("").equals(registro.getCTVoz215())){
				
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				/*strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla34).append(" (");
				strSql.append(W83bMigracionBD.numImpug34).append(",").append(W83bMigracionBD.anoImpug34);
				strSql.append(",").append(W83bMigracionBD.codTerrit34).append(",").append(W83bMigracionBD.numLaudo34);
				strSql.append(",").append(W83bMigracionBD.anoLaudo34).append(",").append(W83bMigracionBD.codVoz34);
				strSql.append(",").append(W83bMigracionBD.codTpVoz34).append(",").append(W83bMigracionBD.sino34);
				strSql.append(") ");
				strSql.append(" VALUES (");
				strSql.append(registro.getNumImpug15()).append(",").append(registro.getAnoImpug15()).append(",");
				strSql.append(registro.getCodTerrit15()).append(",").append(registro.getNumLaudo15()).append(",");*/
				strSql = this.stringTabla34(registro);
				strSql.append(registro.getAnoLaudo15()).append(",").append(registro.getVoz215()).append(",");
				strSql.append(registro.getCTVoz215()).append(",").append(registro.getSino215()).append(")");
				
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}
			if(registro.getCTVoz315()!=null && !("").equals(registro.getCTVoz315())){
				
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				/*strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla34).append(" (");
				strSql.append(W83bMigracionBD.numImpug34).append(",").append(W83bMigracionBD.anoImpug34);
				strSql.append(",").append(W83bMigracionBD.codTerrit34).append(",").append(W83bMigracionBD.numLaudo34);
				strSql.append(",").append(W83bMigracionBD.anoLaudo34).append(",").append(W83bMigracionBD.codVoz34);
				strSql.append(",").append(W83bMigracionBD.codTpVoz34).append(",").append(W83bMigracionBD.sino34);
				strSql.append(") ");
				strSql.append(" VALUES (");
				strSql.append(registro.getNumImpug15()).append(",").append(registro.getAnoImpug15()).append(",");
				strSql.append(registro.getCodTerrit15()).append(",").append(registro.getNumLaudo15()).append(",");*/
				strSql = this.stringTabla34(registro);
				strSql.append(registro.getAnoLaudo15()).append(",").append(registro.getVoz315()).append(",");
				strSql.append(registro.getCTVoz315()).append(",").append(registro.getSino315()).append(")");
				
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}
			if(registro.getCTVoz415()!=null && !("").equals(registro.getCTVoz415())){
				
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				/*strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla34).append(" (");
				strSql.append(W83bMigracionBD.numImpug34).append(",").append(W83bMigracionBD.anoImpug34);
				strSql.append(",").append(W83bMigracionBD.codTerrit34).append(",").append(W83bMigracionBD.numLaudo34);
				strSql.append(",").append(W83bMigracionBD.anoLaudo34).append(",").append(W83bMigracionBD.codVoz34);
				strSql.append(",").append(W83bMigracionBD.codTpVoz34).append(",").append(W83bMigracionBD.sino34);
				strSql.append(") ");
				strSql.append(" VALUES (");
				strSql.append(registro.getNumImpug15()).append(",").append(registro.getAnoImpug15()).append(",");
				strSql.append(registro.getCodTerrit15()).append(",").append(registro.getNumLaudo15()).append(",");*/
				
				strSql = this.stringTabla34(registro);
				strSql.append(registro.getAnoLaudo15()).append(",").append(registro.getVoz415()).append(",");
				strSql.append(registro.getCTVoz415()).append(",").append(registro.getSino415()).append(")");
				
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}
			if(registro.getCTVoz515()!=null && !("").equals(registro.getCTVoz515())){
				
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				/*strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla34).append(" (");
				strSql.append(W83bMigracionBD.numImpug34).append(",").append(W83bMigracionBD.anoImpug34);
				strSql.append(",").append(W83bMigracionBD.codTerrit34).append(",").append(W83bMigracionBD.numLaudo34);
				strSql.append(",").append(W83bMigracionBD.anoLaudo34).append(",").append(W83bMigracionBD.codVoz34);
				strSql.append(",").append(W83bMigracionBD.codTpVoz34).append(",").append(W83bMigracionBD.sino34);
				strSql.append(") ");
				strSql.append(" VALUES (");
				strSql.append(registro.getNumImpug15()).append(",").append(registro.getAnoImpug15()).append(",");
				strSql.append(registro.getCodTerrit15()).append(",").append(registro.getNumLaudo15()).append(",");*/
				
				strSql = this.stringTabla34(registro);
				
				strSql.append(registro.getAnoLaudo15()).append(",").append(registro.getVoz515()).append(",");
				strSql.append(registro.getCTVoz515()).append(",").append(registro.getSino515()).append(")");
				
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}
			
			if(registro.getCodSindi115()!=null && !("").equals(registro.getCodSindi115())){
				
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla35).append(" (");
				strSql.append(W83bMigracionBD.numImpug35).append(",").append(W83bMigracionBD.anoImpug35);
				strSql.append(",").append(W83bMigracionBD.codTerrit35).append(",").append(W83bMigracionBD.codSindi35);
				strSql.append(") ");
				strSql.append(" VALUES (");
				strSql.append(registro.getNumImpug15()).append(",").append(registro.getAnoImpug15()).append(",");
				strSql.append(registro.getCodTerrit15()).append(",").append(registro.getCodSindi115()).append(")");
			
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}
			
			if(registro.getCodSindi215()!=null && !("").equals(registro.getCodSindi215())){
				
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla35).append(" (");
				strSql.append(W83bMigracionBD.numImpug35).append(",").append(W83bMigracionBD.anoImpug35);
				strSql.append(",").append(W83bMigracionBD.codTerrit35).append(",").append(W83bMigracionBD.codSindi35);
				strSql.append(") ");
				strSql.append(" VALUES (");
				strSql.append(registro.getNumImpug15()).append(",").append(registro.getAnoImpug15()).append(",");
				strSql.append(registro.getCodTerrit15()).append(",").append(registro.getCodSindi215()).append(")");
				
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}
			
			if(registro.getCodSindi315()!=null && !("").equals(registro.getCodSindi315())){
				
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla35).append(" (");
				strSql.append(W83bMigracionBD.numImpug35).append(",").append(W83bMigracionBD.anoImpug35);
				strSql.append(",").append(W83bMigracionBD.codTerrit35).append(",").append(W83bMigracionBD.codSindi35);
				strSql.append(") ");
				strSql.append(" VALUES (");
				strSql.append(registro.getNumImpug15()).append(",").append(registro.getAnoImpug15()).append(",");
				strSql.append(registro.getCodTerrit15()).append(",").append(registro.getCodSindi315()).append(")");
				
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}
			
			if(registro.getCodSindi415()!=null && !("").equals(registro.getCodSindi415())){
				
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla35).append(" (");
				strSql.append(W83bMigracionBD.numImpug35).append(",").append(W83bMigracionBD.anoImpug35);
				strSql.append(",").append(W83bMigracionBD.codTerrit35).append(",").append(W83bMigracionBD.codSindi35);
				strSql.append(") ");
				strSql.append(" VALUES (");
				strSql.append(registro.getNumImpug15()).append(",").append(registro.getAnoImpug15()).append(",");
				strSql.append(registro.getCodTerrit15()).append(",").append(registro.getCodSindi415()).append(")");
				
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}
			
			if("E".equals(registro.getEmpresa15())){
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				strSql.append("SELECT ").append(W83bMigracionBD.remiteImp11).append(" FROM ");
				strSql.append(W83bMigracionBD.tablad1615).append(",").append(W83bMigracionBD.tablad1611).append(" WHERE ");
				strSql.append(W83bMigracionBD.numImpug15).append("=").append(registro.getNumImpug15()).append(" AND ");
				strSql.append(W83bMigracionBD.anoImpug15).append("=").append(registro.getAnoImpug15()).append(" AND ");
				strSql.append(W83bMigracionBD.codTerrit15).append("=").append(registro.getCodTerrit15()).append(" AND ");
				strSql.append(W83bMigracionBD.numActa11).append("=").append(W83bMigracionBD.numActa15).append(" AND ");
				strSql.append(W83bMigracionBD.anoElec11).append("=").append(W83bMigracionBD.anoActa15).append(" AND ");
				strSql.append(W83bMigracionBD.codTerrit11).append("=").append(W83bMigracionBD.codTerrit15);
				
				List impugnantes = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
				if(impugnantes.size()>0){
					W83bMigracionBean elImpugnante = (W83bMigracionBean)impugnantes.get(0);
					
					strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
					strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla76).append(" (");
					strSql.append(W83bMigracionBD.anoImpug76).append(",").append(W83bMigracionBD.numImpug76);
					strSql.append(",").append(W83bMigracionBD.codTerrit76).append(",").append(W83bMigracionBD.nombreImp76);
					strSql.append(") ");
					strSql.append(" VALUES (");
					strSql.append(registro.getAnoImpug15()).append(",").append(registro.getNumImpug15()).append(",");
					strSql.append(registro.getCodTerrit15()).append(",").append(elImpugnante.getRemiteImp11()).append(")");
					
					try{
						W83bDataBase.executeTableMovement(strSql.toString(), null,null);
					}
					catch (NamingException e){
						W83bClsTrazas.trazaDebug(null, e+"");
					}
				}
					
			}

			strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
			strSql.append("SELECT ").append(W83bMigracionBD.nomDoc25).append(" , ");
			strSql.append(W83bMigracionBD.logDoc25).append(" , ");
			strSql.append(W83bMigracionBD.doc25).append(" FROM ");
			strSql.append(W83bMigracionBD.tablad1625).append(" WHERE ");
			strSql.append(W83bMigracionBD.numImp25).append("=").append(registro.getNumImpug15()).append(" AND ");
			strSql.append(W83bMigracionBD.anoImp25).append("=").append(registro.getAnoImpug15()).append(" AND ");
			strSql.append(W83bMigracionBD.terrImp25).append("=").append(registro.getCodTerrit15());
			
			List documentos = W83bDataBase.executeQuery(strSql.toString(),null,W83bMigracionBean.class,null,null);
			W83bMigracionBean elDoc = new W83bMigracionBean();//NOPMD
			
			for (int j=0;j<documentos.size();j++){
				elDoc = new W83bMigracionBean();//NOPMD
				elDoc = (W83bMigracionBean)documentos.get(j);
				
				strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
				strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla41).append(" (");
				strSql.append(W83bMigracionBD.idDoc41).append(",").append(W83bMigracionBD.numImpug41);
				strSql.append(",").append(W83bMigracionBD.anoImpug41).append(",").append(W83bMigracionBD.codTerrit41);
				strSql.append(",").append(W83bMigracionBD.codTram41).append(",").append(W83bMigracionBD.codFase41);
				strSql.append(",").append(W83bMigracionBD.nomDoc41);
				strSql.append(",").append(W83bMigracionBD.longDoc41).append(",").append(W83bMigracionBD.doc41);
				//de momento el tipo lo dejamos vacío hasta que se cargue la tabla de tipos de documento
				//strSql.append(",").append(W83bMigracionBD.tipoDoc41);
				strSql.append(") VALUES (");
				strSql.append(j).append(",").append(registro.getNumImpug15()).append(",").append(registro.getAnoImpug15()).append(",");
				strSql.append(registro.getCodTerrit15()).append(", '99', '5',").append(elDoc.getNomDoc25()).append(",");
				strSql.append(elDoc.getLogDoc25()).append(elDoc.getDoc25()).append(")");
				
				try{
					W83bDataBase.executeTableMovement(strSql.toString(), null,null);
				}
				catch (NamingException e){
					W83bClsTrazas.trazaDebug(null, e+"");
				}
			}

		
		}
		W83bClsTrazas.trazaDebug(null, "---------------------------------");
		
	} 
	
	
	public StringBuffer stringTabla34 (W83bMigracionBean registro){
		StringBuffer strSql = new StringBuffer(W83bClsConstantes.CUARENTA);//NOPMD
		strSql.append("INSERT INTO ").append(W83bMigracionBD.tabla34).append(" (");
		strSql.append(W83bMigracionBD.numImpug34).append(",").append(W83bMigracionBD.anoImpug34);
		strSql.append(",").append(W83bMigracionBD.codTerrit34).append(",").append(W83bMigracionBD.numLaudo34);
		strSql.append(",").append(W83bMigracionBD.anoLaudo34).append(",").append(W83bMigracionBD.codVoz34);
		strSql.append(",").append(W83bMigracionBD.codTpVoz34).append(",").append(W83bMigracionBD.sino34);
		strSql.append(") ");
		strSql.append(" VALUES (");
		strSql.append(registro.getNumImpug15()).append(",").append(registro.getAnoImpug15()).append(",");
		strSql.append(registro.getCodTerrit15()).append(",").append(registro.getNumLaudo15()).append(",");
		
		return strSql;
	}
	
}
